Can't assign value to column unless in edit mode (Error 40039)

You attempted to assign a value to a column before calling rdoResultset.Edit or rdoResultset.AddNew.

To avoid this error, make sure the Edit or AddNew method has been called before assigning values to columns with either the Value property or the AppendChunk method.